﻿CREATE TABLE [dbo].[CIMcarinfo]
(
[aid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[carAgency] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[carName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[carType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[carColor] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[carImport] [bit] NULL,
[carCost] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[carCid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[motorId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[motorType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[billid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[eligid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[manifactory] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[paytaxid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[IdentId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[TravId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[RegId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[MortFrom] [datetime] NULL,
[insurer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[insureDate] [datetime] NULL,
[insureDateTo] [datetime] NULL,
[beneficiary] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[insid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[insid1] [bit] NULL,
[insid2] [bit] NULL,
[insid3] [bit] NULL,
[insid4] [bit] NULL,
[insid5] [bit] NULL,
[insid6] [bit] NULL
) ON [PRIMARY]


GO
EXEC sp_addextendedproperty N'MS_Description', N'是，否，国产/进口', 'SCHEMA', N'dbo', 'TABLE', N'CIMcarinfo', 'COLUMN', N'carImport'

